You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
103 lines
4.5 KiB
103 lines
4.5 KiB
USE [FastMoneyPro_Remit]
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[proc_MobileApiLogReports] Script Date: 8/9/2024 10:33:21 AM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
ALTER PROCEDURE [dbo].[proc_MobileApiLogReports]
|
|
(
|
|
@flag VARCHAR(10) = NULL
|
|
,@user VARCHAR(30) = NULL
|
|
,@REQUESTEDBY VARCHAR(100) = NULL
|
|
,@rowId INT = NULL
|
|
,@pageSize INT = NULL
|
|
,@pageNumber INT = NULL
|
|
,@sortBy VARCHAR(50) = NULL
|
|
,@sortOrder VARCHAR(50) = NULL
|
|
,@agentId varchar(20) = NULL
|
|
,@logType VARCHAR(20) = NULL
|
|
,@date VARCHAR(10) = NULL
|
|
,@logby VARCHAR(50) = NULL
|
|
,@controlno VARCHAR(30) = NULL
|
|
,@processid VARCHAR(100) = NULL
|
|
)AS
|
|
SET NOCOUNT ON
|
|
SET XACT_ABORT ON
|
|
BEGIN
|
|
DECLARE
|
|
@table VARCHAR(MAX)
|
|
,@select_field_list VARCHAR(MAX)
|
|
,@extra_field_list VARCHAR(MAX)
|
|
,@sql_filter VARCHAR(MAX)
|
|
|
|
|
|
IF @flag='s'
|
|
BEGIN
|
|
SET @sortBy='rowId'
|
|
SET @sortOrder='DESC'
|
|
SET @table='
|
|
(
|
|
SELECT rowId
|
|
|
|
,ap.createdDate
|
|
,methodName
|
|
,message
|
|
,exception
|
|
,cm.email
|
|
--,cm.customerId
|
|
|
|
FROM logDb.DBO.applicationlogger ap (NOLOCK)
|
|
INNER join customerMaster cm(NOLOCK) on cm.email = ap.createdBy
|
|
|
|
WHERE 1 = 1
|
|
)x'
|
|
|
|
SET @sql_filter = ''
|
|
|
|
|
|
IF @logby IS NOT NULL
|
|
SET @sql_filter=@sql_filter + ' AND email = ''' +@logby+''''
|
|
|
|
|
|
|
|
SET @select_field_list = '
|
|
rowId
|
|
,createdDate
|
|
,MethodName
|
|
,message
|
|
,email
|
|
|
|
'
|
|
|
|
EXEC dbo.proc_paging
|
|
@table
|
|
,@sql_filter
|
|
,@select_field_list
|
|
,@extra_field_list
|
|
,@sortBy
|
|
,@sortOrder
|
|
,@pageSize
|
|
,@pageNumber
|
|
|
|
|
|
|
|
END
|
|
IF @flag='a'
|
|
BEGIN
|
|
SELECT rowId
|
|
|
|
,MethodName methodName
|
|
|
|
,[message] requestXml
|
|
,'' requestXml
|
|
|
|
,createdBy requestedBy
|
|
,createdDate requestedDate
|
|
,'' responseDate
|
|
|
|
|
|
FROM logDb.DBO.applicationlogger (NOLOCK)
|
|
WHERE rowId=@rowId
|
|
END
|
|
END
|